約 4,435,987 件
https://w.atwiki.jp/m_shige1979/pages/601.html
DB2 前提条件 サーバがインストールされている場合 「C \Program Files\IBM\SQLLIB」が存在することを確認 クライアントからの場合 クライアントをインストールして「C \Program Files\IBM\SQLLIB」に存在することを確認 データベースカタログ 設定を行なって、データベースのカタログを行なう サンプルソース /* Standard C/C++ Headers */#include stdio.h #include stdlib.h #include string.h /* DB2 ODBC Header */#include sqlcli1.h int main(int argc, char** argv){ /* Handles */ SQLHENV henv = SQL_NULL_HENV; SQLHDBC hdbc = SQL_NULL_HDBC; SQLHSTMT hstmt= SQL_NULL_HSTMT; /* Local variables */ SQLRETURN rc; SQLCHAR statement[32761]; SQLCHAR mycolout[12]; SQLINTEGER mycoloutlen = 0; char dbname[8 + 1]; char user[18 + 1]; char pswd[30 + 1]; if (argc 4) { printf ("Usage dbconn_ODBC_CLI database name userid password \n"); exit (0); } strcpy (dbname, argv[1]); strcpy (user, argv[2]); strcpy (pswd, argv[3]); rc = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, henv); rc = SQLSetEnvAttr(henv , SQL_ATTR_ODBC_VERSION , (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER); rc = SQLAllocHandle(SQL_HANDLE_DBC, henv, hdbc); /* connect to the database */ rc = SQLConnect(hdbc , (SQLCHAR *)dbname , SQL_NTS , (SQLCHAR *)user , SQL_NTS , (SQLCHAR *)pswd , SQL_NTS); printf ("\n Successful connection to %s db using ODBC/CLI \n",dbname); rc = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, hstmt); strcpy(statement,"SELECT empno"); strcat(statement," FROM DB2INST1.EMPLOYEE;"); rc = SQLExecDirect(hstmt , statement , SQL_NTS); rc = SQLBindCol(hstmt , 1 , SQL_C_CHAR , mycolout , sizeof(mycolout) , mycoloutlen); while((rc = SQLFetch(hstmt)) == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO){ /* Print data */ printf(" Successful retrieval of record. Column empno has a value of %s \n",mycolout); } rc = SQLCloseCursor(hstmt); rc = SQLFreeStmt(hstmt, SQL_RESET_PARAMS); rc = SQLFreeHandle(SQL_HANDLE_STMT, hstmt); rc = SQLDisconnect(hdbc); printf (" Successful Disconnection from database %s \n",dbname); rc = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); rc = SQLFreeHandle(SQL_HANDLE_ENV, henv); printf (" End of Program\n"); return 0; } コンパイル・実行 c \MinGW gcc -I"C \Program Files\IBM\SQLLIB\include" db2_sample01.c -o db2_sample01.exe "C \Program Files\IBM\SQLLIB\lib\db2api.lib" "C \Program Files\IBM\SQLLIB\lib\db2cli.lib" c \MinGW db2_sample01.exe sample db2inst1 xxxxxxx Successful connection to sample db using ODBC/CLI Successful retrieval of record. Column empno has a value of 000010 Successful retrieval of record. Column empno has a value of 000020 Successful retrieval of record. Column empno has a value of 000030 Successful retrieval of record. Column empno has a value of 000050 Successful retrieval of record. Column empno has a value of 000060 Successful Disconnection from database sample End of Program c \MinGW
https://w.atwiki.jp/koroproj/pages/19.html
(新しい順の掲載です) 2012年 Detection of Mobile Objects by Mixture PDF Model for Mobile Robots, システム制御情報学会論文誌,accepted,M. Tanaka,M. Wada,T. Umetani and M. Ito. Target-Tracking based on Fusion of Unsynchronized Sensor Data from Vision System and Thermal Imaging Sensor, システム制御情報学会論文誌,accepted,T. Umetani, N. Kuga, M. Tanaka, M. Wada and M. Ito. Location Estimation of Mobile Wireless LAN Client in Multistory Buildings using Strength of Received Signals in State Space Framework, システム制御情報学会論文誌,accepted, T. Umetani, S. Yamane, T. Yamashita and Y. Tamura. Framework of sensor fusion network for an inverted pendulum mobile robot KoRo,Proc. 43rd Stochastic Systems Symposium, Shiga,pp. 148-152, 2012.M. Wada, M. Tanaka,T. Umetani, T. Kuga, A. Kojima, T. Matsuda, T. Sakai, N. Adachi, K. Inaoka and M. Ito. Detection of mobile objects for outdoor navigation robots, Proc. 43rd Stochastic Systems Symposium, Shiga,pp. 140-147, 2012, M. Tanaka, M. Wada, T. Umetani, M. Ito. Detection of flat ground area by single camera on mobile vehicle,Special Issue on Mobile robotics of the International Journal of Advanced Mechatronic Systems, accepted, Masahiro Tanaka and Shintaro Onishi. Inspection of Ground Condition for a Mobility Scooter by Kinect Sensor,Proc. 2012 RISPInternational Workshop on Nonlinear Circuits, Communications and Signal Processing, Waikiki Beach Marriott Resort Spa, Honolulu, Hawaii, USA, March 4 - 6, 2012, pp. 627-630,Masahiro Tanaka and Hirofumi Kaku Localization of Wireless LAN Client in Multistory Building based on Layered Neural Network, International Journal of Innovative, Computing, Information and Control, vol. 8, no. 3(B), pp. 2301 - 2312,T. Umetani, T. Yamashita and Y. Tamura. 2011年 RTミドルウェアを用いた熱画像センサと視覚デバイスのセンサ情報統合による対象人物追跡, Mem. Konan Univ., Intelli. Inform. Ser., Vol. 4, No. 2, pp.205-212, 久家直倫,梅谷智弘, 田中雅博,和田昌浩, 伊藤稔 コンピュータビジョンによる「だるまさんがころんだ」のオニの実現,高速信号処理応用技術学会論文誌,第14巻第2号, pp. 31-36原田喜貴,田中雅博 Localization of Segway RMP, SICE Annual Conference, September 13-18, 2011, Tokyo, pp. 1675-1680 T. Kuwata,M. Tanaka, M. Wada, T. Umetani and M. Ito Detection of Flat Ground Area by Single Camera on Mobile Vehicles, 2011 International Conference on Advanced Mechatronic Systems, Zhongyuan University of Technology, Zhengzhou, China, August 11-13, 2011, pp.403-408, M. Tanakaand S. Onishi. Probabilistic Localization of Mobile Wireless LAN Client in Multistory Building based on Sparse Bayesian Learning, Journal of Robotics and Mechatronics, vol. 23, no. 4, pp. 475 - 483, 2011.T. Umetani, T. Yamashita and Y. Tamura. Automated Pose Estimation of Object using Multiple ID Devices for Handling and Maintenance Task in Nuclear Fusion Reactor, Plasma and Fusion Research, vol. 6, no. 2406079 (4 pages), 2011,T. Umetani, J. Morioka, K. Inoue, T. Arai, Y. Mae and Y. Tamura. Data Acquisition for Stochastic Localization of Wireless Mobile Client in Multistory Building, Proc. of 28th International Symposium on Automation and Robotics in Construction, Seoul, June 29 - July 2, pp. 1364 - 1369, 2011,T. Umetani, T. Yamashita and Y. Tamura. Framework of Control and Stabilization System for an Inverted Pendulum Moving Robot, 42nd International Symposium on Stochastic Systems and Its Applications, Okayama, Nov. 26-27, 2010,pp. 1-5,M. Wada, M. Tanaka, T. Umetani and M. Ito Localization of Mobile Client in Multistory Building using Public Wireless LAN System,42nd International Symposium on Stochastic Systems and Its Applications, Okayama, Nov. 26-27, 2010, pp. 6-12,T. Umetani, T. Yamashita and Y. Tamura Mobile Robot Localization Using Differential Evolution,42nd International Symposium on Stochastic Systems and Its Applications, Okayama, Nov. 26-27, 2010,pp. 13-18,M. Ito and M. Tanaka Localization of Moving Robots By Using Omnidirectional Camera in State Space Framework,42nd International Symposium on Stochastic Systems and Its Applications, Okayama, Nov. 26-27, 2010, pp. 19-26,M. Tanaka, T. Umetani, H. Hirano,M. Wada and M. Ito (技術研究報告)キャンパスロボットKoRoの開発 -全体構想とシステム基盤構築-,Mem. Konan Univ., Intelli. Inform. Ser., Vol. 4, No. 1, accepted (25 pages),田中雅博,和田昌浩,梅谷智弘,伊藤稔 2010年 Automated Three-Dimensional Pose Estimation of Objects using Multiple ID Devices by Autonomous Robot, Proceedings of the 5th International Conference on Advanced Mechatronics, Osaka, JAPAN, October 2-4, 2010, pp. 534 - 539,Tomohiro Umetani, Jun-ichi Morioka, Kenji Inoue, Yasushi Mae and Tatsuo Arai. Localization of a Moving Robot by Sensor Fusion, 2010 RISP International Workshop on Nonlinear Circuits, Communications and Signal Processing Waikiki Beach Marriott Resort Spa, Honolulu, Hawaii, USA March 3-5, 2010, pp. 556-559,Masahiro Tanaka, Hiroaki Hirano, Shintaro Onishi,Tomohiro Umetani and Masahiro Wada Target-Tracking based on Fusion of Unsynchronized Sensor Data from Vision System and Thermal Imaging Sensor, システム制御情報学会論文誌,accepted,T. Umetani, N. Kuga,M. Tanaka,M. Wada,M. Ito. Location Estimation of Mobile Wireless LAN Client in Multistory Buildings using Strength of Received Signals in State Space Framework, システム制御情報学会論文誌,accepted,T. Umetani, S. Yamane, T. Yamashita and Y. Tamura. Sensor fusion of vision system and thermal imaging sensor for target tracking,, Proc. 43rd Stochastic Systems Symposium, Shiga,pp. 165-168,T. Umetani,N. Kuga,M. Tanaka, M. Wadaand M. Ito.
https://w.atwiki.jp/picturesql/pages/6.html
更新履歴 @wikiのwikiモードでは #recent(数字) と入力することで、wikiのページ更新履歴を表示することができます。 詳しくはこちらをご覧ください。 =>http //atwiki.jp/guide/17_117_ja.html たとえば、#recent(20)と入力すると以下のように表示されます。 取得中です。
https://w.atwiki.jp/ramstorage/pages/15.html
■対応するSATA Host controller (ANS-9010/9010B Product Compatible List 2009/02/03更新版より) +Intel RAIDアレイ構築時のストライプサイズは大きいほど速度・体感共に上昇。 最大設定値の128kを推奨。 ICH6R ICH7/R ICH8/R ICH9/R ICH10R ICH8R:単体接続はOK、但しRAIDモードにするとPOSTに2分かかる上にRAID構築に失敗する [35枚目468](新ファームでコンパチリスト入り,修正されたか?) +ATI SB400 SB600 SB750 +nVidia nForce 750a SLI nForce 590 SLI(C51XE+MCP55PXE):OK [38枚目480] nForce 680i SLI:OK [37枚目515] nForce 780a:SATA Spread SpectrumをOFFにしたらOKっぽい? [38枚目657] nForce Professional 2200:OK [37枚目137], [37枚目439] nForce Professional 3600+3050(MCP55):OK [37枚目460] ■ nVidia(support 1.5G only) nForce430 nForce550 nForce4-Ultra nForce 570 SLI nForce Pro 3600 +3ware 9500S-8 :(認識せず) [35枚目743] 9550SX-4LP (FW:FE9X 3.04.00.005):問題なく認識。RAIDも問題なく構築可能 [35枚目273] 9690SA-8I:問題なく認識。RAIDも問題なく構築可能 [35枚目294] +Adaptec ASR-2405:RAID0 OK (速度遅め)[35枚目104],[37枚目182],[38枚目494] RAID 51245:NG (書き込み等行おうとするとフリーズ) [35枚目739] RAID 5805:OK (但し4K遅い) [35枚目399],[38枚目200] SAS 53800 (PCIX-133):Legacyのみ動作。RAIDは構築できず。[35枚目823] +Areca 動作可否 ANS-9010(B):○ ARC-1110 (firmware ?):[34枚目707] ARC-1120 (PCIX-133):[35枚目824] ARC-1210 (firmware v1.46):[35枚目273], [36枚目705] ARC-1220 (firmware v1.44):[35枚目459] , (firmware ?) OK [34枚目357,707],[36枚目62] ARC-1680(無印):[35枚目104] ANS-9010(B):△ ARC-1231ML:(NCQをOFF) [36枚目795], [37枚目522] ARC-1261ML:(NCQをOFF) [37枚目368] ARC-1680ix-12:(firmware ?)(SATA2だとフォーマット時にエラー。SATA1だと動くけどいい数字は出ない) [36枚目601] ANS-9010(B):× ARC-1210 (firmware v1.43):認識するがステータスFaildと表示されアレイを作成不可。 [35枚目273] ARC-1680ix-12:(firmware v1.45) Timeout出てNG。容量誤認識 [36枚目273] ARC-1680ix-16:(Timeoutでアレイが壊れる) [35枚目557] +Broadcom RAIDCore BC4452 (PCIX-100):OK (但し遅い) [35枚目83] +DELL SAS 6/iR (LSI SAS 1068E):OK (NCQをOFF) [37枚目97] +HighPoint RocketRAID 1740:OK [35枚目814],[36枚目330] RocketRAID 1820A:(9010B複数台接続時 RAID BIOSで止まる)環境によりけり? [37枚目110, 112] RocketRAID 2310:OK [35枚目736] RocketRAID 2320:OK [37枚目121] RocketRAID 2522:OK [36枚目717] RocketRAID 3320:OK [37枚目961] RocketRAID 3520:OK [AKIBA PC Hotline 他複数] RocketRAID 4320:OK (3520と比べると少し遅い) [35枚目801],ファーム更新でシーケンシャル速度UP [38枚目543] +LaCie RAIDアレイ構築時のクラスタサイズは最小8k・最大128k。 8kを推奨。 動作可否 i-RAM:○ ANS-9010(B):○ SATA II 3Gbits/s PCI-Express Card 4E (SiliconImage SiI3124) [終息商品](RAID0時Random4K速い) [AKIBA PC Hotline], [36枚目617] +LSI 3041E:OK [33枚目774] Logic MegaRAID SAS 8208XLP:OK [36枚目417] Logic MegaRAID SAS 8408E:OK [37枚目258] Logic MEGARAID SATA 300-8X (PCIX-100):NG (認識に時間かかりアダプタ自体を見失う事がある)[35枚目81],[35枚目403] Logic MegaRAID 8888ELP (firmware 1.20.02-0447):OK RAID0 [37枚目71] Logic SAS 3080X-R (PCIX-133):OK (4Port RAID0) [35枚目822] SAS 1068E(Tyan i5400PW):OK [37枚目231] +MAXSERVE ES-4000PCIX (SiI3124):OK [37枚目460]
https://w.atwiki.jp/honeybe/pages/49.html
psql -U username ユーザ名 -W password パスワード -d dbname 接続するデータベースを指定 -c query 指定されたクエリを実行し終了する。 -f filename ファイルに記載されたクエリを実行し終了する。 -o filename 問い合わせ結果をファイル出力する。 -q psqlメッセージの出力を抑制する。 -t カラム名/結果の行数フッタなどの出力を抑制する。 psql 上のコマンド \q psqlを終了する。 \c [{dbname} [{username}]}] データベースに接続する。 \cd {dir} 作業ディレクトリを変更する。 \e [{filename}] 編集。引数無し:チャンクの編集。引数あり:ファイルを編集後、チャンクに入れる。 \o [{filename} || {command}] 以降の問い合わせ結果をファイル出力 / パイプ経由で別コマンドへ。引数無し:標準出力に表示。 \w [{filename} || {command}] 現在の問い合わせ結果をファイル出力 / パイプ経由で別コマンドへ。 \s [{filename}] 履歴をファイルに保存。引数無しの場合:標準出力に表示。 \d {relation} テーブル等の情報表示 \l DB一覧とその所有者を表示 \h ヘルプ表示
https://w.atwiki.jp/aerocats/pages/51.html
標準Linuxの/usr/local/bin/内にある。 スクリプト #!/bin/sh # KURO-BOX/PRO shell script common routines. # Ver 1.002007/01/17 new by Y.H. # DEFAULT_IP=192.168.11.150 ENETNAME=eth0 #setup global environment values. MTD_SHARE=`grep extra /proc/mtd| sed -e "s/ .*//"` MTD_UIMAGE=`grep uImage /proc/mtd|sed -e "s/ .*//"` MTD_ROOTFS=`grep rootfs /proc/mtd|sed -e "s/ .*//"` MTD_UBOOT=mtd0 MTD_SHARE_DEV=/dev/${MTD_SHARE} MTD_UIMAGE_DEV=/dev/${MTD_UIMAGE} MTD_ROOTFS_DEV=/dev/${MTD_ROOTFS} MTD_RBOOT_DEV=/dev/${MTD_UBOOT} MTD_UIMAGE_CHARDEV_MINORNUM=`echo ${MTD_UIMAGE_DEV}|sed -e "s/.*mtd//"|sed -e "s/.*mtdblock//"` MTD_UIMAGE_CHARDEV=/dev/mtdchar${MTD_UIMAGE_CHARDEV_MINORNUM} MTD_ROOTFS_CHARDEV_MINORNUM=`echo ${MTD_ROOTFS_DEV}|sed -e "s/.*mtd//"|sed -e "s/.*mtdblock//"` MTD_ROOTFS_CHARDEV=/dev/mtdchar${MTD_ROOTFS_CHARDEV_MINORNUM} MTD_SHARE_CHARDEV_MINORNUM=`echo ${MTD_SHARE_DEV}|sed -e "s/.*mtd//"|sed -e "s/.*mtdblock//"` MTD_SHARE_CHARDEV=/dev/mtdchar${MTD_SHARE_CHARDEV_MINORNUM} DISK1_DEV=/dev/sda DISK2_DEV=/dev/sdb DISK1_MPT=/mnt/disk1 DISK2_MPT=/mnt/disk2 MTD_MPT=/mnt/mtd RAMDISK_MPT=/mnt/ram RAMDISK_DEV=/dev/ram1 RAMDISK_SIZE=8 KERNEL_EVENT_TAIL=/proc/buffalo/kernevnt FIRST_NAND=/etc/first_boot MICONAPL=/usr/local/sbin/miconapl HEXDUMP=/usr/bin/hexdump CHANGE_TO_DEVHDD_FILE=${MTD_MPT}/ChangeMeDevHDD SCSI_MAJOR=8 SCSI1_MINOR_BASE=0 SCSI2_MINOR_BASE=16 # $1 device of check target # retval # 1 device $1 is mounted. # 0 device $1 is not mounted. IsMounted(){ MOUNTED=`grep $1 /proc/mounts` if [ "${MOUNTED}" != "" ] ; then return 1 else return 0 fi return 0 } # $1 return value of evaluate target. DispSF(){ if [ "$1" -eq 0 ] ; then echo [Success] else echo [Failed ] fi } # $1 Executing shellscript. (mainly used for rcS) # $2 Option(default is start) exec_sh(){ if [ ! x"$2" = x"" ] ; then EXEC_OPT=$2 else EXEC_OPT=start fi echo "" echo "===== Starting $1 =====" /etc/init.d/$1 ${EXEC_OPT} DispSF $? echo "" } # $1 Check target mount point. CheckMPT(){ if [ "$1" != "" ] ; then echo "Checking MPT($1) is exist or not." if [ ! -e "$1" ] ; then echo "$1 not exist. So create a directory, now." mkdir $1 -p chmod 777 $1 else echo "$1 is exist. So no need to create a directory." fi else echo "Checking MPT target is something wrong." fi } create_sysfolder(){ rm -rf ${RAMDISK_MPT} mkdir -m 777 -p ${RAMDISK_MPT} mount -t tmpfs -o mode=1777,size=${RAMDISK_SIZE}m ${RAMDISK_DEV} ${RAMDISK_MPT} if [ $? -ne 0 ] ; then echo "*** ERROR! ${RAMDISK_MPT} mount fail!!" reboot -f fi mkdir -m 777 -p /mnt/ram/tmp /mnt/ram/var/tmp /mnt/ram/var/run rm -rf /tmp /var ln -sf /mnt/ram/tmp /tmp ln -sf /mnt/ram/var /var mkdir -m 777 -p /var/lock mkdir -m 755 -p /var/empty/sshd mkdir -m 755 -p /var/lib/dhcp mkdir -m 755 -p /var/lib/nfs chown rpcuser rpcuser /var/lib/nfs mkdir -m 755 -p /var/lock/subsys mkdir -m 755 -p /var/lock/perfmon mkdir -m 755 -p /var/lock/printing mkdir -m 755 -p /var/log/hotplug mkdir -m 755 -p /var/log/samba mkdir -m 755 -p /var/log/linkstation mkdir -m 755 -p /var/run/usb mkdir -m 755 -p /var/spool ln -s /etc/cron /var/spool/cron MODEL=`grep PRODUCTNAME /proc/buffalo/firmware|sed -e "s/PRODUCTNAME=//"` echo "KUROUTOSHIKOU KUROBOX Series ${MODEL}" /etc/issue ln -sf issue /etc/issue.net rm -f /var/lock/* } # $1 target device to format Format_EXT3(){ echo "***** Starting to format $1 *****" mkfs.ext3 $1 if [ $? -eq 0 ] ; then echo "Format is succeeded without error." else return 1 exit 1 fi return 0 } # $1 target device to format. Format_XFS(){ KEY=`dd if=$1 bs=1 count=3` if [ "${KEY}" = "XFS" ] ; then . /etc/melco/info if [ "${force_format}" = "yes" ] ; then echo "Disk (or partition) is looks like already formatted." echo "If you stop format, Press Ctrl+C in 10 seconds!!!" COUNTER=10 echo -n "waiting " while [ ${COUNTER} -gt 0 ] do echo -n "." sleep 1 COUNTER=$((${COUNTER} - 1)) done echo "" echo "OK, go on formatting." else return 0 fi fi echo "***** Cleaning Disk partition information *****" dd if=/dev/zero of=$1 bs=512 count=1 echo "***** Starting to format $1 *****" mkfs.xfs $1 -f if [ $? -eq 0 ] ; then echo "Format is succeeded without error." else return 1 exit 1 fi return 0 } # $1 target device to check partition # ret 0 this is no partition disk. # ret 1 this is nand share type partition # ret 2 this is developkit type partition (maybe) IsHavePartition(){ if [ -x ${HEXDUMP} ] ; then DISK_1_PART_TAIL=`hexdump -s 446 -n 64 -e 8/1 "%02x " 2/4 "%10d " "\n" $1 | sed -n "1p"|awk {print $10} ` DISK_2_PART_TAIL=`hexdump -s 446 -n 64 -e 8/1 "%02x " 2/4 "%10d " "\n" $1 | sed -n "2p"|awk {print $10} ` DISK_3_PART_TAIL=`hexdump -s 446 -n 64 -e 8/1 "%02x " 2/4 "%10d " "\n" $1 | sed -n "3p"|awk {print $10} ` DISK_4_PART_TAIL=`hexdump -s 446 -n 64 -e 8/1 "%02x " 2/4 "%10d " "\n" $1 | sed -n "4p"|awk {print $10} ` if [ "${DISK_1_PART_TAIL}" -ne 0 -a "${DISK_2_PART_TAIL}" -eq 0 -a "${DISK_3_PART_TAIL}" -eq 0 -a "${DISK_4_PART_TAIL}" -eq 0 ] ; then return 1 elif [ "${DISK_1_PART_TAIL}" -ne 0 -a "${DISK_2_PART_TAIL}" -ne 0 -a "${DISK_3_PART_TAIL}" -ne 0 -a "${DISK_4_PART_TAIL}" -ne 0 ] ; then return 2 else return 0 fi else return 0 fi return 0 } # $1 target device to mount. # $2 target mountpoint of $1. # $3 File system of target device(default is xfs). # $4 Mounted device permission(default is 777). MountShare(){ # ret 0 this is no partition disk. # ret 1 this is nand share type partition # ret 2 this is developkit type partition (maybe) if [ "$1" = "/dev/sda" -o "$1" = "/dev/sdb" ] ; then IsHavePartition $1 RET=$? [ "${RET}" -eq 1 ] TARGET_DEV=${1}1 [ "${RET}" -eq 2 ] TARGET_DEV=${1}4 [ "${RET}" -eq 0 ] TARGET_DEV=${1} else TARGET_DEV=$1 fi IsMounted ${TARGET_DEV} if [ $? = 1 ] ; then echo "${TARGET_DEV} is already mounted." return 1 fi if [ "$3" = "" ] ; then FS=xfs else FS=$3 fi if [ "$4" = "" ] ; then PERMISSION=777 else PERMISSION=$4 fi echo "Mounting ${TARGET_DEV} on $2 as a ${FS} file system." mount -t ${FS} ${TARGET_DEV} $2 case $? in 0) chmod ${PERMISSION} $2 echo "Success." ;; *) echo "Failed." return 1 ;; esac echo "" return 0 } MiconIntEnable(){ cat /proc/buffalo/miconint_en } CreateDevFile(){ DISK_DEV=$1 case ${DISK_DEV} in ${DISK1_DEV}) SCSI_MINOR_BASE=${SCSI1_MINOR_BASE} [ ! -e ${DISK_DEV} ] mknod ${DISK_DEV} b ${SCSI_MAJOR} ${SCSI_MINOR_BASE} ;; ${DISK2_DEV}) SCSI_MINOR_BASE=${SCSI2_MINOR_BASE} [ ! -e ${DISK_DEV} ] mknod ${DISK_DEV} b ${SCSI_MAJOR} ${SCSI_MINOR_BASE} ;; *) return -1 esac SCSI_MINOR=$((${SCSI_MINOR_BASE} + 1)) DEV_NO=1 while [ ${DEV_NO} -lt 8 ] do [ ! -e ${DISK_DEV}${DEV_NO} ] mknod ${DISK_DEV}${DEV_NO} b ${SCSI_MAJOR} ${SCSI_MINOR} DEV_NO=$((${DEV_NO} + 1)) SCSI_MINOR=$((${SCSI_MINOR} + 1)) done } lock_file(){ case $1 in check) [ -f "${LOCK}" ] echo "${THIS_SCRIPT} already runnign" return 1 ;; create) echo "${THIS_SCRIPT}" $2 ${LOCK} ;; delete) rm -f ${LOCK} ;; delete_log) rm -f ${LOCK}.log ;; *) ;; esac }
https://w.atwiki.jp/ituki6136/pages/35.html
MySQLとかいろいろメモ インストール 初期ログイン:mysql -u root rootパスワード設定 コピー Apacheのインストール 2.2.15 ID anonymous パスワード:なし cd /pub/apache/httpd アンインストール # rm -rf /usr/local/apache ↑ここまでできた MySQLのデータベースを別サーバーに移行する ログアウト・新しいユーザでログイン 新規ユーザの追加 Vi コマンド [Esc]→保存[:wq] アンインストール yum remove mysql viで行表示 set number LinuxにPHPをインストール ./configure --with-apxs2=/usr/local/httpd-2.2.15/bin/apxs --enable-magic-quotes --with-xml --enable-mbregex --enable-mbstring --enable-zend-multibyte --with-mysql=/ebs0/var/lib/mysql --enable-ftp --with-zlib --with-openssl --with-libdir=lib64 libxml2でエラーが出たら http //blog.goo.ne.jp/nhiro4/e/08f4fd3dfe82549865bd9d96ec744765 libxml2-2.7.3.tar.gz php.iniの設定 with-libdir=lib64 AmazonEC2マウント
https://w.atwiki.jp/elvis/pages/4175.html
Evaluating AIDS Prevention Contributions of Multiple Disciplines (New Directions for Evaluation) Jossey-Bass Inc Pub? Laura C. Leviton? Andrea M. Hegedus? Alan Kubrin? Jossey-BassIncPub? LauraC.Leviton? AndreaM.Hegedus? AlanKubrin? ジャンル別-mirror-test-test-subtier-AIDS&HIV? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-PersonalHealth-General? Subjects-Medicine-Administration&Policy-PublicHealth? Subjects-Medicine-Diseases-AIDS&HIV? Subjects-Nonfiction-Education-Curricula? Subjects-Nonfiction-Education-LessonPlanning? Subjects-Professional&Technical-Education-LessonPlanning? Subjects-Professional&Technical-Education-Curricula? Subjects-Science-General Subjects-Science-Medicine-Administration&Policy-PublicHealth? Subjects-Science-Medicine-Diseases-AIDS&HIV? Paying for Services Promises and Pitfalls of Capitation (Jossey-Bass Social and Behavioral Scienc) Jossey-Bass Inc Pub? David Mechanic? Laura H. Aiken? Jossey-BassIncPub? DavidMechanic? LauraH.Aiken? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-Psychiatry? Subjects-Medicine-Specialties-Psychiatry-General? Subjects-Professional&Technical-Medical-Medicine-InternalMedicine-Psychiatry-General? Subjects-Science-Medicine-Specialties-Psychiatry-General? State-University Collaboration The Oregon Experience (New Directions for Mental Health Services) Jossey-Bass Inc Pub? Joseph D. Bloom? Jossey-BassIncPub? JosephD.Bloom? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-Psychiatry? Subjects-Medicine-Specialties-Psychiatry-General? Subjects-Professional&Technical-Medical-Medicine-InternalMedicine-Psychiatry-General? Subjects-Science-Medicine-Specialties-Psychiatry-General? Serving the Chronically Mentally Ill in an Urban Setting The Massachusetts Mental Health Center Experience (New Directions for Youth Development) Jossey-Bass Inc Pub? Miles F. Shore? Jon E. Gudeman? Jossey-BassIncPub? MilesF.Shore? JonE.Gudeman? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-Psychiatry? Subjects-Medicine-Administration&Policy-PublicHealth? Subjects-Medicine-Specialties-Psychiatry-General? Subjects-Professional&Technical-Medical-Medicine-InternalMedicine-Psychiatry-CommunityMentalHealth? Subjects-Science-Medicine-Administration&Policy-PublicHealth? Subjects-Science-Medicine-Specialties-Psychiatry-General? Enhancing Articulation and Transfer (Jossey Bass Higher and Adult Education Series) Jossey-Bass Inc Pub? Carolyn Prager? Jossey-BassIncPub? CarolynPrager? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Professional&Technical-Education-ByLevel-College? Issues in Personnel Management (New Directions for Community Colleges) Jossey-Bass Inc Pub? Richare I. Miller? Edward W. Holzapfel? Jossey-BassIncPub? RichareI.Miller? EdwardW.Holzapfel? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Professional&Technical-Education-ByLevel-College? The Perspective of John a Talbott (New Directions for Mental Health Services, No 37) Jossey-Bass Inc Pub? John A. Talbott? Jossey-BassIncPub? JohnA.Talbott? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-MentalIllness? Subjects-Health,Mind&Body-Psychology&Counseling-Psychiatry? Subjects-Medicine-Administration&Policy-PublicHealth? Subjects-Medicine-Specialties-Psychiatry-General? Subjects-Professional&Technical-Medical-Medicine-InternalMedicine-Psychiatry-MentalHealthServices? Subjects-Science-Medicine-Administration&Policy-PublicHealth? Subjects-Science-Medicine-Specialties-Psychiatry-General? College Teaching and Learning Preparing for New Commitments (New Directions for Teaching and Learning) Jossey-Bass Inc Pub? Robert E. Young? Kenneth Eugene Eble? Jossey-BassIncPub? RobertE.Young? KennethEugeneEble? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Nonfiction-Education-InstructionMethod? Subjects-Professional&Technical-Education-ByLevel-College? Teaching Large Classes Well (New Directions for Teaching and Learning, No 32, Winter 1987) Jossey-Bass Inc Pub? Maryellen Gleason Weimer? Jossey-BassIncPub? MaryellenGleasonWeimer? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Nonfiction-Education-InstructionMethod? Subjects-Professional&Technical-Education-ByLevel-College? Techniques for Evaluating and Improving Instruction (New Directions for Teaching and Learning) Jossey-Bass Inc Pub? Lawrence M. Aleamoni? Jossey-BassIncPub? LawrenceM.Aleamoni? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Nonfiction-Education-InstructionMethod? Improving Mental Health Services What the Social Sciences Can Tell Us (New Directions for Youth Development) Jossey-Bass Inc Pub? David Mechanic? Jossey-BassIncPub? DavidMechanic? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-MentalIllness? Subjects-Law-Specialties-Disability? Subjects-Nonfiction-Law-Specialties-Disability? Leona Bachrach Speaks Selected Speeches and Lectures (New Directions for Mental Health Services, No 35) Jossey-Bass Inc Pub? Leona L. Bachrach? Jossey-BassIncPub? LeonaL.Bachrach? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling? Subjects-Health,Mind&Body-MentalHealth-General? Subjects-Professional&Technical-Medical-Medicine-InternalMedicine-Psychiatry-MentalHealthServices? Managing Information in Higher Education (Jossey Bass Higher and Adult Education Series) Jossey-Bass Inc Pub? Michael E. Staman? Jossey-BassIncPub? MichaelE.Staman? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Nonfiction-Education-EducationTheory-Administration? Subjects-Nonfiction-Education-General? Subjects-Professional&Technical-Education-ByLevel-College? Subjects-Professional&Technical-Education-Administration-General? Student Outcomes Assessment What Institutions Stand to Gain (New Directions for Higher Education, No 59, Fall 1987) Jossey-Bass Inc Pub? Diane F. Halpern? Jossey-BassIncPub? DianeF.Halpern? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Subjects-Reference-Education-Testing? Optimal Decision Making Jossey-Bass Inc Pub? Stuart S. Nagel? Jossey-BassIncPub? StuartS.Nagel? undefined undefined Teaching the Developmental Education Student (New Directions for Community Colleges) Jossey-Bass Inc Pub? Kenneth M. Ahrendt? Jossey-BassIncPub? KennethM.Ahrendt? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-Pedagogy? Subjects-Nonfiction-Education-College&University-General? Subjects-Professional&Technical-Education-Pedagogy? Conducting Interinstitutional Comparisons (New Directions for Institutional Research, No 53, Spring 1987) Jossey-Bass Inc Pub? Paul T. Brinkman? Jossey-BassIncPub? PaulT.Brinkman? Substores-UnknownASINs-35 Subjects-Nonfiction-SocialSciences-Methodology? Subjects-Nonfiction-SocialSciences-Research? Subjects-Reference-Education-Research? Designing and Using Market Research (Jossey-Bass Higher Education Series) Jossey-Bass Inc Pub? Robert S. Lay? Jean J. Endo? Jossey-BassIncPub? RobertS.Lay? JeanJ.Endo? Substores-UnknownASINs-35 Subjects-Business&Investing-Marketing&Sales-Marketing-General? Subjects-Nonfiction-SocialSciences-Methodology? Subjects-Nonfiction-SocialSciences-Research? Subjects-Professional&Technical-BusinessManagement-Marketing&Sales-Marketing-General? Barriers to Treating the Chronic Mentally Ill (New Directions for Mental Health Services, No 33) Jossey-Bass Inc Pub? Arthuur T. Meyerson? Jossey-BassIncPub? ArthuurT.Meyerson? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling-MentalIllness? Subjects-Law-Specialties-Disability? Subjects-Nonfiction-Law-Specialties-Disability? Families of the Mentally Ill Meeting the Challenge (Jossey-Bass Social and Behavioral Sciences Ser) Jossey-Bass Inc Pub? Agnes B. Hatfield? Jossey-BassIncPub? AgnesB.Hatfield? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling? Subjects-Health,Mind&Body-MentalHealth-General? Responding to the Needs of Today's Minority Students (Jossey Bass Higher and Adult Education Series) Jossey-Bass Inc Pub? Doris J. Wright? Jossey-BassIncPub? DorisJ.Wright? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-College&University-General? Personnel Strategies and Productivity Improvement Jossey-Bass Inc Pub? Charles Davis? Jossey-BassIncPub? CharlesDavis? undefined undefined Eating Disorders (New Directions for Youth Development) Jossey-Bass Inc Pub? Felix E. F. Larocca? Jossey-BassIncPub? FelixE.F.Larocca? Substores-UnknownASINs-35 Subjects-Health,Mind&Body-Psychology&Counseling? Subjects-Health,Mind&Body-PersonalHealth-Women sHealth-EatingDisorders? Measuring Efficiency An Assessment of Data Envelopment Analysis (New Directions for Evaluation) Jossey-Bass Inc Pub? Richard H. Silkman? Jossey-BassIncPub? RichardH.Silkman? Substores-UnknownASINs-35 Subjects-Business&Investing-Management&Leadership-Management? Subjects-Nonfiction-SocialSciences-Methodology? Subjects-Professional&Technical-BusinessManagement-Management&Leadership-Management? Distinguished Teachers on Effective Teaching (New Directions for Teaching and Learning) Jossey-Bass Inc Pub? Peter G. Beidler? Jossey-BassIncPub? PeterG.Beidler? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-Pedagogy? Subjects-Nonfiction-Education-College&University-General? Subjects-Professional&Technical-Education-Pedagogy? Sugi Supplemental Library Users Guide Sas Inst? SasInst? undefined undefined Sas Guide to Tabulate Processing 1987 Sas Inst? SasInst? undefined undefined Sas-Stat User's Guide Release 6.03 Edition Sas Inst? SasInst? undefined undefined Sas Procedures Guide Release 6.03 Edition Sas Inst? SasInst? undefined undefined Sas Introductory Guide Release 6.03 Sas Inst? SasInst? undefined undefined Sas/Assist Software Changes and Enhancements, Version 6 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet? Categorical Data Analysis Using the Sas System Sas Inst? Maura E. Stokes? Charles S. Davis? Gary G. Koch? SasInst? MauraE.Stokes? CharlesS.Davis? GaryG.Koch? Substores-UnknownASINs-35 Subjects-Computers&Internet? Subjects-Science-Mathematics-Applied-Probability&Statistics? Sas - Qc Software Reference, Version 6. Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-General? Sas/Assist Software Your Interface to the Sas System, Version 6 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet? Subjects-Science-Mathematics-Applied-Probability&Statistics? Sas Technical Report P-197, the Trantab Procedure, Release 6.06 Sas Inst? SasInst? undefined undefined Getting Started With the Sas System Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Science-Mathematics-Applied-Probability&Statistics? Sas/Af Software, Sas/Fsp Software, and Sas Screen Control Language Changes and Enhancements Release 6.07 (Sas Technical Report P-216) Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-OperatingSystems-General? Sas Screen Control Language Syntax, Version 6 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-Programming-Languages&Tools-General? Subjects-Science-Mathematics-Applied-Probability&Statistics? Sas/English Software User's Guide, Version X Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-Programming-General? Beyond the Obvious With Sas Screen Control Language Sas Inst? Don Stanley? SasInst? DonStanley? Substores-UnknownASINs-35 Subjects-Computers&Internet? Sas Software Roadmaps Your Guide to Discovering the Sas System Sas Inst? Laurie Burch? Sherrijoyce King? SasInst? LaurieBurch? SherrijoyceKing? Substores-UnknownASINs-35 Subjects-Computers&Internet? Microsoft Windows Environment Changes and Enhancements to the Sas System, Release 6.10 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-Programming-General? Jmp User's Guide, Version 3.1 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-Networking-DataintheEnterprise-StatisticalComputing? Subjects-Professional&Technical-ProfessionalScience-Mathematics-Applied-Statistics? Subjects-Science-Mathematics-Applied-Probability&Statistics? Jmp Statistics and Graphics Guide, Version 3.1 Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-Networking-DataintheEnterprise-StatisticalComputing? Advanced General Linear Models With an Emphasis on Mixed Models Sas Inst? SasInst? Substores-UnknownASINs-35 Subjects-Computers&Internet-OperatingSystems? Sas/Cpe Software Reference, Version 6 Sas Inst? SasInst? undefined undefined American Art Analog Mda? Michael Zellman? Mda? MichaelZellman? Substores-UnknownASINs-35 Subjects-Arts&Photography-Art-Painting-General? Subjects-Children sBooks? The Federal Aviation Administration (Know Your Government) Mda? Robert Burkhardt? Fred L. Israel? Mda? RobertBurkhardt? FredL.Israel? Substores-UnknownASINs-35 Subjects-Law-AdministrativeLaw-FederalJurisdiction? Subjects-Nonfiction-Law-AdministrativeLaw-FederalJurisdiction? House of Representatives (Know Your Government) Chelsea House Pub (L)? Bruce A. Ragsdale? ChelseaHousePub(L)? BruceA.Ragsdale? Substores-UnknownASINs-35 Subjects-Children sBooks? Immigration and Naturalization Service (Know Your Government) Chelsea House Pub (L)? Edward H. Dixon? Mark A. Galan? ChelseaHousePub(L)? EdwardH.Dixon? MarkA.Galan? Substores-UnknownASINs-35 Subjects-Nonfiction-Education-General? Substores-UnknownASINs-35 洋書
https://w.atwiki.jp/paladin/pages/37.html
2010/01/05 MySQLでBLOB型の列にPDFファイルを挿入して、ブラウザで取り出して 表示する方法を友人に聞かれて答えられなかったので調べてみた。 BLOBについて簡単におさらい。 BLOB は様々な大きさのデータを保持する事ができる大きいバイナリオブジェクトです。 4つの BLOB タイプは、TINYBLOB、 BLOB、MEDIUMBLOB、そしてLONGBLOB です。 MySQL5.1リファレンスマニュアルより DBに格納するところまではできたそうなので、取り出すところだけやってみる。 テーブル構造はこんな感じ DB名 blobtest テーブル名 test フィールド 種別 備考 id int 一意になるコード data longblob 今回の本命、バイナリデータ 格納データはこんな感じで準備 id data 0 (PDFデータ) 1 (画像データ) いずれもネットで拾ってきたデータ。 PHPのファイルはバイナリデータそのものを返す"view_data.php" バイナリデータを呼び出す"view_main.php"の2ファイルを用意。 view_data.php ?phpheader( Content-type application/pdf ); //MySQLサーバに接続$con = mysql_connect("server", "user", "password");IF (!$con){ print("MySQLへの接続に失敗しました"); exit;} //DB接続IF (!mysql_select_db("blobtest")){ print("データベースへの接続に失敗しました"); exit;} $sql = "select data from test where id=0"; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo $row[0]; ? view_main.php html head meta http-equiv=”Content-TYPE” content=”text/html; charset=UTF-8” title PDF表示 /title /head body a href="view_data.php" target="new" PDF表示 /a /body /html ※ここまで書いて気づいたけど、"view_main.php"はただのHTMLでよかった。 ファイルは別窓に表示したいということだったので、 a タグには target="new" を入れている。 もしクリックした時に表示ではなくダウンロードにしたいなら、 "view_data.php"の3行目に下記の1行を追加すればOK。 header( Content-Disposition attachment; filename="downloaded.pdf" ); 最低限のことしか記述してないけど、伝わると幸いです。 今回はここまで。 =============== ここから宣伝(自動追加) ===============
https://w.atwiki.jp/picturesql/pages/11.html
コメントプラグイン @wikiのwikiモードでは #comment() と入力することでコメントフォームを簡単に作成することができます。 詳しくはこちらをご覧ください。 =>http //atwiki.jp/guide/17_60_ja.html たとえば、#comment() と入力すると以下のように表示されます。 名前 コメント